SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598395 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598395 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503360,931557,989713,866122,474710,21727,94398,1019017,481632,303190,335085,161279,1019108,195300,934043,812079,704681,658242,999619,741937,981713,547913,852828,650998,630177,698090,347817,788065,988640,237044,125094,501771,922853,638418,467529,465622,852683,475675,1039736,908585,284174,331109,320223,865293,954614,590266,1043626,384073,346521,872417,382177,946724,634889,620157,504849,879236,149961,890721,171462,629870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]