SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002024s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014073 LIMIT 1 [ RunTime:0.001026s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014073 [ RunTime:0.002875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635255,956462,200545,169472,902017,374586,570002,574424,653909,60580,752372,204456,727204,392897,465011,674315,422845,737308,211206,949322,82138,739535,672697,967057,823325,179340,650160,39744,747404,578610,119527,242961,431838,798365,504087,130039,307601,985858,466346,471526,532452,239570,289875,977519,442120,207876,416745,750048,914594,100295,810144,889062,936662,894777,859577,244941,235241,661438,129885,829325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]