SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180328 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180328 [ RunTime:0.002642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320244,333510,528818,188387,564552,206312,370078,515133,1009723,852949,186602,28969,1021913,867396,269438,478700,27357,34572,240627,872552,362317,616263,393380,366929,546717,167956,108253,430693,44166,537,1041676,575767,743483,457959,65370,752921,521461,558895,558733,704663,479047,789671,539895,840302,139464,1001219,951616,697976,415467,316968,397472,825716,398236,760350,7048,436610,730548,654023,105065,822011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]