SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509316 LIMIT 1 [ RunTime:0.000715s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509316 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481208,156584,716898,1015783,137803,866110,232044,610583,710714,886837,344231,756921,802210,996392,1003962,462450,74711,479542,788576,16466,400320,495856,383178,291664,802483,154997,159544,788392,73033,523917,258731,596240,166396,106352,708195,284433,577938,312557,345856,464335,166946,452649,342010,1046521,976259,565518,298931,995152,435186,990920,898939,650622,155718,878583,523488,786517,142336,484802,940255,850424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001612s ]