SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414718 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414718 [ RunTime:0.003110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69569,663513,322729,251473,905701,726444,638562,278209,326274,855918,118932,521651,47809,85595,781305,186055,765765,977475,185107,194224,661994,1032710,1034590,6053,600265,971053,1023715,521172,735368,767153,791311,682874,244302,455549,702800,35377,540235,214336,363301,996149,945744,452638,29030,529247,106465,459015,156395,642173,43047,394391,87530,300057,745235,254272,432543,334211,112104,1002741,917763,7254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]