SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480453 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480453 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802851,284856,116244,552563,841574,509070,1043521,84668,242855,813060,190009,141697,968368,122577,86671,308689,16793,895927,363153,292593,565348,563249,606251,312899,977639,1024455,50675,801214,482283,445760,807495,372035,541750,887361,386268,255877,116588,978520,211458,129847,362482,355478,309267,357903,139995,8014,504451,280373,877375,242625,142492,993227,538866,355434,645150,432896,472463,952924,282278,142980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]