SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002005s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417185 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417185 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333404,279872,142525,929953,895036,990908,962590,163246,768998,395050,151847,300285,356121,320459,522953,145028,87479,5502,19847,874012,918961,179300,384707,515247,656438,43826,768195,862251,797290,59682,200456,379078,847946,934687,519225,676543,635275,425627,965183,830973,574477,62958,114091,811667,592573,490417,282877,169548,977361,1043773,138695,820617,185439,387926,431499,986627,52266,201811,42896,1021835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]