SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553876 LIMIT 1 [ RunTime:0.000761s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553876 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487008,178796,261047,154974,128486,653574,1013978,792170,104247,524171,385242,837630,280828,19209,854169,803807,768348,1007450,132035,384425,1018133,1028185,159591,895111,262900,739944,12461,1047839,532316,848050,712856,280654,80655,558668,806446,295435,36181,515613,862713,333083,531960,224778,691740,1017420,475537,89773,600280,773758,548245,317573,718865,423947,282251,264218,269796,630116,508420,695184,273685,456244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]