SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544533 LIMIT 1 [ RunTime:0.000563s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544533 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647343,559281,134665,189755,968090,420561,464851,101774,910517,744677,757340,406094,86150,473011,258042,226276,965086,500082,635783,786401,205123,153768,832068,804201,249852,84358,157370,289173,574773,826180,932285,689647,171197,508032,64798,109440,356228,1020034,727346,338790,101398,357748,597589,994486,118197,194279,97264,82781,44750,629600,153806,929710,712608,380461,564999,17946,710238,162877,185877,165095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]