SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599543 LIMIT 1 [ RunTime:0.003128s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599543 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85086,84395,507571,59883,166346,732099,190046,992608,1040773,980860,994027,1040063,14479,441269,806692,286695,110261,680143,1018101,462492,491499,668507,531841,644844,40082,740447,443612,570907,872514,358766,1018061,389167,760656,369418,898849,564690,817128,967478,31111,754998,499046,339720,496328,824966,436079,116994,441027,879688,879741,1030932,765954,495386,152945,781391,346826,844522,274955,974073,665364,322860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004070s ]