SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341620 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341620 [ RunTime:0.002582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838274,430017,752316,238460,144720,78115,216670,231557,524697,313442,1002028,43302,145590,177354,267120,355840,867647,862172,945870,902257,620128,55836,282272,632989,431370,983304,85436,136175,735886,144567,296348,318575,594274,351913,85517,556806,614380,361367,936436,851911,882037,664749,746539,790284,933049,322058,169370,185181,553642,898595,469958,307335,441691,558951,59718,949164,481644,191921,657558,941504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000734s ]