SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315415 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315415 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928877,665487,387641,38673,282226,840467,155692,185530,811851,565176,569077,511006,122281,854882,768781,690606,377144,399334,837460,994688,338565,475002,268900,529869,641980,665043,594810,436243,764770,72645,52081,119566,1008448,589532,1041214,1007033,666108,569311,402652,665841,901346,512863,109736,651923,570423,321747,711636,188412,124707,443956,58145,233183,21159,418333,458007,804587,816540,697706,114866,602892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000815s ]