SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014322 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014322 [ RunTime:0.003927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744138,698690,141507,796025,966603,636625,391313,349170,224378,1025610,101376,868339,604917,1011861,439362,792675,1046610,240358,1019022,293066,1588,777609,689946,167121,882766,38285,764978,96974,32586,630270,533009,571332,311882,901480,477566,446338,565308,313154,754792,767431,189623,289923,494694,354424,771734,817245,121305,634959,705,886812,795630,516653,707364,177084,230274,111159,446255,148997,183547,218112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]