SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020479 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020479 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50323,192601,194376,171446,811035,190840,850794,159769,936671,739527,768990,13338,313671,291638,670023,1048699,36330,630536,280412,560539,470883,617786,521718,226537,749696,984705,86277,407409,793312,327857,766778,1639,456107,25812,920675,517218,507721,370247,289040,384307,488814,47908,885143,628565,601370,287281,679,139631,173107,357295,383117,231260,132953,146519,151697,722256,962144,985710,70493,534936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]