SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014276 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014276 [ RunTime:0.003350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548140,502167,783095,594655,669056,669440,916241,200041,529639,727491,74466,355284,1013147,731934,979096,898451,167350,421761,322066,534700,170922,941238,1019099,917556,900388,835638,895425,696057,45565,1013465,464896,332841,866712,129870,37941,791006,178694,892484,770220,425480,367895,775876,97706,478481,283729,853976,1044238,207231,165023,127727,690564,287869,343005,740533,180927,1030692,945773,28933,753152,779855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]