SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173661 LIMIT 1 [ RunTime:0.000844s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173661 [ RunTime:0.002790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018005,262780,103760,664088,315267,439610,143843,711601,412025,656781,243931,59044,16010,897838,432940,911048,103122,499508,390893,896226,93677,550505,954188,532908,916943,360318,421186,414849,1007479,297949,90260,798284,804542,271745,286722,666442,82950,60259,608284,288987,122325,907844,72854,30141,508424,948208,61451,278296,941657,42036,23783,750499,584753,1021889,567012,623011,84694,96856,671,936622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]