SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108841 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108841 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530027,654714,899228,949816,696411,352507,881545,145277,1017480,996080,95157,702414,952681,922588,50164,946038,351886,997885,305258,922685,35310,793714,883190,127408,376883,638734,882569,238059,414144,175243,644698,166877,243926,162421,111815,608847,437308,655761,319892,473080,767676,32981,854143,325107,256252,557322,213951,496737,44748,811647,855177,224160,165877,62849,130277,198064,497194,958514,866243,583025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000754s ]