SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105761 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105761 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346654,201574,135680,191393,155595,258437,36908,399025,814403,1000856,784763,650880,544280,739021,470273,431611,424255,1014346,951785,874653,821974,426040,68541,848158,1018850,941623,398609,949436,504196,493027,498352,1028564,742636,485009,631082,67658,947723,767442,575105,653107,457152,138961,349183,789566,847102,645747,407738,737601,325537,963956,941107,468623,961969,358373,137879,997712,759944,37833,208426,967730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000792s ]