SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284378 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284378 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736779,213872,140798,20791,347600,807297,913289,50739,8003,691063,82962,287980,924609,950496,570478,1022362,762384,440441,483007,658916,416975,530824,876625,827870,495717,383355,416160,562851,175926,110440,603697,979478,919054,273803,438499,67565,97323,666658,54512,941738,445450,781016,1033896,1030050,896923,574145,706562,1038551,992929,336391,579278,266926,942908,272561,593056,1036926,481966,929543,811563,690631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]