SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489032 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489032 [ RunTime:0.004305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814181,23421,168922,734322,917513,672961,519898,385934,33205,944182,929595,55730,433697,910257,309623,756543,334564,501974,939173,371641,284014,708178,661998,583598,425562,232845,706028,615447,453936,32459,121844,130257,465833,1041505,524623,421704,518497,562160,632026,622012,111068,1000878,501125,1029936,628306,711495,398421,331646,712492,383965,141191,969123,628938,241518,765408,594314,271407,467713,679862,795968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000994s ]