SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292645 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292645 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540574,298379,858677,707882,967279,155231,547700,171740,477038,384256,373434,455999,773254,1046643,827588,425834,176827,797844,151743,185447,172806,256104,1043197,727599,120155,791808,372515,410185,1007666,423331,39345,320121,1035980,250878,60603,911003,118590,1006041,503913,594006,586075,730020,436309,664276,436581,529497,670897,197275,880229,370914,341274,369305,438439,469594,854790,423267,52268,733779,213814,700372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001645s ]