SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036531 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036531 [ RunTime:0.002580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152433,346675,369885,1036333,900913,303987,326328,279582,732216,650666,695597,918063,509797,451564,76928,557243,148544,1014122,89130,1001500,488393,281145,721100,836068,344112,413835,903956,331203,912788,481519,171828,352029,914035,112453,678825,642759,805575,329433,611614,506993,859151,339923,87888,299171,1047504,630873,634021,969252,985069,335930,461422,440435,986050,454890,879184,96027,98237,790314,413331,52565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]